package com.laborder.sysyy.dao;
import com.laborder.sysyy.entity.College;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;
/**
 * @Function: 学院Dao层
 * @author: 786107529@qq.com FJL
 * @date:2018/9/8 17:30
 */
@Repository
@Mapper
public interface CollegeDaoMapper {
	 /**
	  * @Function: 分页查询
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:32
	  */
	 List<College> findCollegeWithPage(Map<String, Object> map);
	List<College> findAllCollege();
	 /**
	  * @Function: 查询总数
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:33
	  */
	 int getCollegeCount(Map<String, Object> map);
	 /**
	  * @Function: 添加学院
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:33
	  */
	 int saveCollegeInfo(College college);
	 /**
	  * @Function: 根据ID删除学院
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:33
	  */
	 int delCollegeInfo(int clId);
	 /**
	  * @Function: 根据ID查询
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:33
	  */
	 College getCollegeInfo(String clId);
	 /**
	  * @Function: 更新学院信息
	  * @author: 786107529@qq.com FJL
	  * @date:2018/9/8 17:33
	  */
	 int updateCollegeInfo(College college);

	 /**
	   * @function: 查询学院信息
	   * @author: 759057893@qq.com lyz
	   * @date: 2019/1/11 10:59
	   */
	 List<College> selectCollege();

	College findCollegeByName(String clName);
}
